package com.yuncheng.spcyApi.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.yuncheng.spcyApi.entity.SpcyXcjcBjdd;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @Description: 审评查验-现场检查笔记地点
 * @Author: yuncheng
 * @Date: 2024-06-24
 * @Version: V1.0
 */
public interface SpcyXcjcBjddMapper extends BaseMapper<SpcyXcjcBjdd> {

    /** 根据检查地点id-查询申请事项id */
    String selectFsqsxidById(@Param("id") String id);

    /** 文件检查情况-查询文件类型历史 */
    List<String> selectHistoryFwjflBySqsxId(@Param("sqsxid") String sqsxid);

    /** 现场检查笔记地点-查询地点车间历史 */
    List<String> selectHistoryFddcjBySqsxId(@Param("sqsxid") String sqsxid);

    /** 现场检查笔记地点-查询具体库历史 */
    List<String> selectHistoryFjtkBySqsxId(@Param("sqsxid") String sqsxid);

}
